package com.zhongwang.mms.gen.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class MInventoryExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MInventoryExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andItyIdIsNull() {
            addCriterion("ity_id is null");
            return (Criteria) this;
        }

        public Criteria andItyIdIsNotNull() {
            addCriterion("ity_id is not null");
            return (Criteria) this;
        }

        public Criteria andItyIdEqualTo(Integer value) {
            addCriterion("ity_id =", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdNotEqualTo(Integer value) {
            addCriterion("ity_id <>", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdGreaterThan(Integer value) {
            addCriterion("ity_id >", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_id >=", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdLessThan(Integer value) {
            addCriterion("ity_id <", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdLessThanOrEqualTo(Integer value) {
            addCriterion("ity_id <=", value, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdIn(List<Integer> values) {
            addCriterion("ity_id in", values, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdNotIn(List<Integer> values) {
            addCriterion("ity_id not in", values, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdBetween(Integer value1, Integer value2) {
            addCriterion("ity_id between", value1, value2, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_id not between", value1, value2, "ityId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdIsNull() {
            addCriterion("ity_mat_id is null");
            return (Criteria) this;
        }

        public Criteria andItyMatIdIsNotNull() {
            addCriterion("ity_mat_id is not null");
            return (Criteria) this;
        }

        public Criteria andItyMatIdEqualTo(Integer value) {
            addCriterion("ity_mat_id =", value, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdNotEqualTo(Integer value) {
            addCriterion("ity_mat_id <>", value, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdGreaterThan(Integer value) {
            addCriterion("ity_mat_id >", value, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_mat_id >=", value, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdLessThan(Integer value) {
            addCriterion("ity_mat_id <", value, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdLessThanOrEqualTo(Integer value) {
            addCriterion("ity_mat_id <=", value, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdIn(List<Integer> values) {
            addCriterion("ity_mat_id in", values, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdNotIn(List<Integer> values) {
            addCriterion("ity_mat_id not in", values, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdBetween(Integer value1, Integer value2) {
            addCriterion("ity_mat_id between", value1, value2, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyMatIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_mat_id not between", value1, value2, "ityMatId");
            return (Criteria) this;
        }

        public Criteria andItyInTypeIsNull() {
            addCriterion("ity_in_type is null");
            return (Criteria) this;
        }

        public Criteria andItyInTypeIsNotNull() {
            addCriterion("ity_in_type is not null");
            return (Criteria) this;
        }

        public Criteria andItyInTypeEqualTo(Integer value) {
            addCriterion("ity_in_type =", value, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeNotEqualTo(Integer value) {
            addCriterion("ity_in_type <>", value, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeGreaterThan(Integer value) {
            addCriterion("ity_in_type >", value, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_in_type >=", value, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeLessThan(Integer value) {
            addCriterion("ity_in_type <", value, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeLessThanOrEqualTo(Integer value) {
            addCriterion("ity_in_type <=", value, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeIn(List<Integer> values) {
            addCriterion("ity_in_type in", values, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeNotIn(List<Integer> values) {
            addCriterion("ity_in_type not in", values, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeBetween(Integer value1, Integer value2) {
            addCriterion("ity_in_type between", value1, value2, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyInTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_in_type not between", value1, value2, "ityInType");
            return (Criteria) this;
        }

        public Criteria andItyProCodeIsNull() {
            addCriterion("ity_pro_code is null");
            return (Criteria) this;
        }

        public Criteria andItyProCodeIsNotNull() {
            addCriterion("ity_pro_code is not null");
            return (Criteria) this;
        }

        public Criteria andItyProCodeEqualTo(String value) {
            addCriterion("ity_pro_code =", value, "ityProCode");
            return (Criteria) this;
        }
        public Criteria andItyPositionEqualTo(String value) {
            addCriterion("ity_position =", value, "ityPosition");
            return (Criteria) this;
        }

        public Criteria andItyProCodeNotEqualTo(String value) {
            addCriterion("ity_pro_code <>", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeGreaterThan(String value) {
            addCriterion("ity_pro_code >", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_pro_code >=", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeLessThan(String value) {
            addCriterion("ity_pro_code <", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_pro_code <=", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeLike(String value) {
            addCriterion("ity_pro_code like", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeNotLike(String value) {
            addCriterion("ity_pro_code not like", value, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeIn(List<String> values) {
            addCriterion("ity_pro_code in", values, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeNotIn(List<String> values) {
            addCriterion("ity_pro_code not in", values, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeBetween(String value1, String value2) {
            addCriterion("ity_pro_code between", value1, value2, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProCodeNotBetween(String value1, String value2) {
            addCriterion("ity_pro_code not between", value1, value2, "ityProCode");
            return (Criteria) this;
        }

        public Criteria andItyProNameIsNull() {
            addCriterion("ity_pro_name is null");
            return (Criteria) this;
        }

        public Criteria andItyProNameIsNotNull() {
            addCriterion("ity_pro_name is not null");
            return (Criteria) this;
        }

        public Criteria andItyProNameEqualTo(String value) {
            addCriterion("ity_pro_name =", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameNotEqualTo(String value) {
            addCriterion("ity_pro_name <>", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameGreaterThan(String value) {
            addCriterion("ity_pro_name >", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameGreaterThanOrEqualTo(String value) {
            addCriterion("ity_pro_name >=", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameLessThan(String value) {
            addCriterion("ity_pro_name <", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameLessThanOrEqualTo(String value) {
            addCriterion("ity_pro_name <=", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameLike(String value) {
            addCriterion("ity_pro_name like", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameNotLike(String value) {
            addCriterion("ity_pro_name not like", value, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameIn(List<String> values) {
            addCriterion("ity_pro_name in", values, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameNotIn(List<String> values) {
            addCriterion("ity_pro_name not in", values, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameBetween(String value1, String value2) {
            addCriterion("ity_pro_name between", value1, value2, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItyProNameNotBetween(String value1, String value2) {
            addCriterion("ity_pro_name not between", value1, value2, "ityProName");
            return (Criteria) this;
        }

        public Criteria andItySpecIsNull() {
            addCriterion("ity_spec is null");
            return (Criteria) this;
        }

        public Criteria andItySpecIsNotNull() {
            addCriterion("ity_spec is not null");
            return (Criteria) this;
        }

        public Criteria andItySpecEqualTo(String value) {
            addCriterion("ity_spec =", value, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecNotEqualTo(String value) {
            addCriterion("ity_spec <>", value, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecGreaterThan(String value) {
            addCriterion("ity_spec >", value, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecGreaterThanOrEqualTo(String value) {
            addCriterion("ity_spec >=", value, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecLessThan(String value) {
            addCriterion("ity_spec <", value, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecLessThanOrEqualTo(String value) {
            addCriterion("ity_spec <=", value, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecLike(String value) {
            addCriterion("ity_spec like", value, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecNotLike(String value) {
            addCriterion("ity_spec not like", value, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecIn(List<String> values) {
            addCriterion("ity_spec in", values, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecNotIn(List<String> values) {
            addCriterion("ity_spec not in", values, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecBetween(String value1, String value2) {
            addCriterion("ity_spec between", value1, value2, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItySpecNotBetween(String value1, String value2) {
            addCriterion("ity_spec not between", value1, value2, "itySpec");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeIsNull() {
            addCriterion("ity_track_code is null");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeIsNotNull() {
            addCriterion("ity_track_code is not null");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeEqualTo(String value) {
            addCriterion("ity_track_code =", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeNotEqualTo(String value) {
            addCriterion("ity_track_code <>", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeGreaterThan(String value) {
            addCriterion("ity_track_code >", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_track_code >=", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeLessThan(String value) {
            addCriterion("ity_track_code <", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_track_code <=", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeLike(String value) {
            addCriterion("ity_track_code like", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeNotLike(String value) {
            addCriterion("ity_track_code not like", value, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeIn(List<String> values) {
            addCriterion("ity_track_code in", values, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeNotIn(List<String> values) {
            addCriterion("ity_track_code not in", values, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeBetween(String value1, String value2) {
            addCriterion("ity_track_code between", value1, value2, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyTrackCodeNotBetween(String value1, String value2) {
            addCriterion("ity_track_code not between", value1, value2, "ityTrackCode");
            return (Criteria) this;
        }

        public Criteria andItyNumIsNull() {
            addCriterion("ity_num is null");
            return (Criteria) this;
        }

        public Criteria andItyNumIsNotNull() {
            addCriterion("ity_num is not null");
            return (Criteria) this;
        }

        public Criteria andItyNumEqualTo(Double value) {
            addCriterion("ity_num =", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumNotEqualTo(Double value) {
            addCriterion("ity_num <>", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumGreaterThan(Double value) {
            addCriterion("ity_num >", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_num >=", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumLessThan(Double value) {
            addCriterion("ity_num <", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumLessThanOrEqualTo(Double value) {
            addCriterion("ity_num <=", value, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumIn(List<Double> values) {
            addCriterion("ity_num in", values, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumNotIn(List<Double> values) {
            addCriterion("ity_num not in", values, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumBetween(Double value1, Double value2) {
            addCriterion("ity_num between", value1, value2, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyNumNotBetween(Double value1, Double value2) {
            addCriterion("ity_num not between", value1, value2, "ityNum");
            return (Criteria) this;
        }

        public Criteria andItyWeightIsNull() {
            addCriterion("ity_weight is null");
            return (Criteria) this;
        }

        public Criteria andItyWeightIsNotNull() {
            addCriterion("ity_weight is not null");
            return (Criteria) this;
        }

        public Criteria andItyWeightEqualTo(Double value) {
            addCriterion("ity_weight =", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightNotEqualTo(Double value) {
            addCriterion("ity_weight <>", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightGreaterThan(Double value) {
            addCriterion("ity_weight >", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_weight >=", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightLessThan(Double value) {
            addCriterion("ity_weight <", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightLessThanOrEqualTo(Double value) {
            addCriterion("ity_weight <=", value, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightIn(List<Double> values) {
            addCriterion("ity_weight in", values, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightNotIn(List<Double> values) {
            addCriterion("ity_weight not in", values, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightBetween(Double value1, Double value2) {
            addCriterion("ity_weight between", value1, value2, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyWeightNotBetween(Double value1, Double value2) {
            addCriterion("ity_weight not between", value1, value2, "ityWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumIsNull() {
            addCriterion("ity_ava_num is null");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumIsNotNull() {
            addCriterion("ity_ava_num is not null");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumEqualTo(Double value) {
            addCriterion("ity_ava_num =", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumNotEqualTo(Double value) {
            addCriterion("ity_ava_num <>", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumGreaterThan(Double value) {
            addCriterion("ity_ava_num >", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_ava_num >=", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumLessThan(Double value) {
            addCriterion("ity_ava_num <", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumLessThanOrEqualTo(Double value) {
            addCriterion("ity_ava_num <=", value, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumIn(List<Double> values) {
            addCriterion("ity_ava_num in", values, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumNotIn(List<Double> values) {
            addCriterion("ity_ava_num not in", values, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumBetween(Double value1, Double value2) {
            addCriterion("ity_ava_num between", value1, value2, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaNumNotBetween(Double value1, Double value2) {
            addCriterion("ity_ava_num not between", value1, value2, "ityAvaNum");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightIsNull() {
            addCriterion("ity_ava_weight is null");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightIsNotNull() {
            addCriterion("ity_ava_weight is not null");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightEqualTo(Double value) {
            addCriterion("ity_ava_weight =", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightNotEqualTo(Double value) {
            addCriterion("ity_ava_weight <>", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightGreaterThan(Double value) {
            addCriterion("ity_ava_weight >", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_ava_weight >=", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightLessThan(Double value) {
            addCriterion("ity_ava_weight <", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightLessThanOrEqualTo(Double value) {
            addCriterion("ity_ava_weight <=", value, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightIn(List<Double> values) {
            addCriterion("ity_ava_weight in", values, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightNotIn(List<Double> values) {
            addCriterion("ity_ava_weight not in", values, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightBetween(Double value1, Double value2) {
            addCriterion("ity_ava_weight between", value1, value2, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyAvaWeightNotBetween(Double value1, Double value2) {
            addCriterion("ity_ava_weight not between", value1, value2, "ityAvaWeight");
            return (Criteria) this;
        }

        public Criteria andItyBackDateIsNull() {
            addCriterion("ity_back_date is null");
            return (Criteria) this;
        }

        public Criteria andItyBackDateIsNotNull() {
            addCriterion("ity_back_date is not null");
            return (Criteria) this;
        }

        public Criteria andItyBackDateEqualTo(String value) {
            addCriterion("ity_back_date =", value, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateNotEqualTo(String value) {
            addCriterion("ity_back_date <>", value, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateGreaterThan(String value) {
            addCriterion("ity_back_date >", value, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateGreaterThanOrEqualTo(String value) {
            addCriterion("ity_back_date >=", value, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateLessThan(String value) {
            addCriterion("ity_back_date <", value, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateLessThanOrEqualTo(String value) {
            addCriterion("ity_back_date <=", value, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateLike(String value) {
            addCriterion("ity_back_date like", value, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateNotLike(String value) {
            addCriterion("ity_back_date not like", value, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateIn(List<String> values) {
            addCriterion("ity_back_date in", values, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateNotIn(List<String> values) {
            addCriterion("ity_back_date not in", values, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateBetween(String value1, String value2) {
            addCriterion("ity_back_date between", value1, value2, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyBackDateNotBetween(String value1, String value2) {
            addCriterion("ity_back_date not between", value1, value2, "ityBackDate");
            return (Criteria) this;
        }

        public Criteria andItyRemarkIsNull() {
            addCriterion("ity_remark is null");
            return (Criteria) this;
        }

        public Criteria andItyRemarkIsNotNull() {
            addCriterion("ity_remark is not null");
            return (Criteria) this;
        }

        public Criteria andItyRemarkEqualTo(String value) {
            addCriterion("ity_remark =", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkNotEqualTo(String value) {
            addCriterion("ity_remark <>", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkGreaterThan(String value) {
            addCriterion("ity_remark >", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("ity_remark >=", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkLessThan(String value) {
            addCriterion("ity_remark <", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkLessThanOrEqualTo(String value) {
            addCriterion("ity_remark <=", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkLike(String value) {
            addCriterion("ity_remark like", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkNotLike(String value) {
            addCriterion("ity_remark not like", value, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkIn(List<String> values) {
            addCriterion("ity_remark in", values, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkNotIn(List<String> values) {
            addCriterion("ity_remark not in", values, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkBetween(String value1, String value2) {
            addCriterion("ity_remark between", value1, value2, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyRemarkNotBetween(String value1, String value2) {
            addCriterion("ity_remark not between", value1, value2, "ityRemark");
            return (Criteria) this;
        }

        public Criteria andItyPriceIsNull() {
            addCriterion("ity_price is null");
            return (Criteria) this;
        }

        public Criteria andItyPriceIsNotNull() {
            addCriterion("ity_price is not null");
            return (Criteria) this;
        }

        public Criteria andItyPriceEqualTo(Double value) {
            addCriterion("ity_price =", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceNotEqualTo(Double value) {
            addCriterion("ity_price <>", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceGreaterThan(Double value) {
            addCriterion("ity_price >", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("ity_price >=", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceLessThan(Double value) {
            addCriterion("ity_price <", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceLessThanOrEqualTo(Double value) {
            addCriterion("ity_price <=", value, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceIn(List<Double> values) {
            addCriterion("ity_price in", values, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceNotIn(List<Double> values) {
            addCriterion("ity_price not in", values, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceBetween(Double value1, Double value2) {
            addCriterion("ity_price between", value1, value2, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyPriceNotBetween(Double value1, Double value2) {
            addCriterion("ity_price not between", value1, value2, "ityPrice");
            return (Criteria) this;
        }

        public Criteria andItyAmountIsNull() {
            addCriterion("ity_amount is null");
            return (Criteria) this;
        }

        public Criteria andItyAmountIsNotNull() {
            addCriterion("ity_amount is not null");
            return (Criteria) this;
        }

        public Criteria andItyAmountEqualTo(BigDecimal value) {
            addCriterion("ity_amount =", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountNotEqualTo(BigDecimal value) {
            addCriterion("ity_amount <>", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountGreaterThan(BigDecimal value) {
            addCriterion("ity_amount >", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ity_amount >=", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountLessThan(BigDecimal value) {
            addCriterion("ity_amount <", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ity_amount <=", value, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountIn(List<BigDecimal> values) {
            addCriterion("ity_amount in", values, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountNotIn(List<BigDecimal> values) {
            addCriterion("ity_amount not in", values, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ity_amount between", value1, value2, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ity_amount not between", value1, value2, "ityAmount");
            return (Criteria) this;
        }

        public Criteria andItyStoIdIsNull() {
            addCriterion("ity_sto_id is null");
            return (Criteria) this;
        }

        public Criteria andItyStoIdIsNotNull() {
            addCriterion("ity_sto_id is not null");
            return (Criteria) this;
        }

        public Criteria andItyStoIdEqualTo(Integer value) {
            addCriterion("ity_sto_id =", value, "ityStoId");
            return (Criteria) this;
        }
        public Criteria andSupplierTo(String value) {
            addCriterion("supplier =", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andItyStoIdNotEqualTo(Integer value) {
            addCriterion("ity_sto_id <>", value, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoIdGreaterThan(Integer value) {
            addCriterion("ity_sto_id >", value, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_sto_id >=", value, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoIdLessThan(Integer value) {
            addCriterion("ity_sto_id <", value, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoIdLessThanOrEqualTo(Integer value) {
            addCriterion("ity_sto_id <=", value, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoIdIn(List<Integer> values) {
            addCriterion("ity_sto_id in", values, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoIdNotIn(List<Integer> values) {
            addCriterion("ity_sto_id not in", values, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoIdBetween(Integer value1, Integer value2) {
            addCriterion("ity_sto_id between", value1, value2, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_sto_id not between", value1, value2, "ityStoId");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumIsNull() {
            addCriterion("ity_sto_place_num is null");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumIsNotNull() {
            addCriterion("ity_sto_place_num is not null");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumEqualTo(String value) {
            addCriterion("ity_sto_place_num =", value, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumNotEqualTo(String value) {
            addCriterion("ity_sto_place_num <>", value, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumGreaterThan(String value) {
            addCriterion("ity_sto_place_num >", value, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumGreaterThanOrEqualTo(String value) {
            addCriterion("ity_sto_place_num >=", value, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumLessThan(String value) {
            addCriterion("ity_sto_place_num <", value, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumLessThanOrEqualTo(String value) {
            addCriterion("ity_sto_place_num <=", value, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumLike(String value) {
            addCriterion("ity_sto_place_num like", value, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumNotLike(String value) {
            addCriterion("ity_sto_place_num not like", value, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumIn(List<String> values) {
            addCriterion("ity_sto_place_num in", values, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumNotIn(List<String> values) {
            addCriterion("ity_sto_place_num not in", values, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumBetween(String value1, String value2) {
            addCriterion("ity_sto_place_num between", value1, value2, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyStoPlaceNumNotBetween(String value1, String value2) {
            addCriterion("ity_sto_place_num not between", value1, value2, "ityStoPlaceNum");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeIsNull() {
            addCriterion("ity_mat_sap_code is null");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeIsNotNull() {
            addCriterion("ity_mat_sap_code is not null");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeEqualTo(String value) {
            addCriterion("ity_mat_sap_code =", value, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeNotEqualTo(String value) {
            addCriterion("ity_mat_sap_code <>", value, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeGreaterThan(String value) {
            addCriterion("ity_mat_sap_code >", value, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ity_mat_sap_code >=", value, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeLessThan(String value) {
            addCriterion("ity_mat_sap_code <", value, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeLessThanOrEqualTo(String value) {
            addCriterion("ity_mat_sap_code <=", value, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeLike(String value) {
            addCriterion("ity_mat_sap_code like", value, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeNotLike(String value) {
            addCriterion("ity_mat_sap_code not like", value, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeIn(List<String> values) {
            addCriterion("ity_mat_sap_code in", values, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeNotIn(List<String> values) {
            addCriterion("ity_mat_sap_code not in", values, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeBetween(String value1, String value2) {
            addCriterion("ity_mat_sap_code between", value1, value2, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyMatSapCodeNotBetween(String value1, String value2) {
            addCriterion("ity_mat_sap_code not between", value1, value2, "ityMatSapCode");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagIsNull() {
            addCriterion("ity_ceo_source_flag is null");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagIsNotNull() {
            addCriterion("ity_ceo_source_flag is not null");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagEqualTo(Integer value) {
            addCriterion("ity_ceo_source_flag =", value, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagNotEqualTo(Integer value) {
            addCriterion("ity_ceo_source_flag <>", value, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagGreaterThan(Integer value) {
            addCriterion("ity_ceo_source_flag >", value, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("ity_ceo_source_flag >=", value, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagLessThan(Integer value) {
            addCriterion("ity_ceo_source_flag <", value, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagLessThanOrEqualTo(Integer value) {
            addCriterion("ity_ceo_source_flag <=", value, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagIn(List<Integer> values) {
            addCriterion("ity_ceo_source_flag in", values, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagNotIn(List<Integer> values) {
            addCriterion("ity_ceo_source_flag not in", values, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagBetween(Integer value1, Integer value2) {
            addCriterion("ity_ceo_source_flag between", value1, value2, "ityCeoSourceFlag");
            return (Criteria) this;
        }

        public Criteria andItyCeoSourceFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("ity_ceo_source_flag not between", value1, value2, "ityCeoSourceFlag");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}